COUNTIF

This counts the number of occurrences that meet a given criteria.

COUNTIF(range, criteria)

• Range (Required) is one or more fields that contain numbers.
• Criteria (Required) is a number, expression, or text string that defines which records to be counted. For example, criteria can be expressed as 3, ">3","Normal", or "3".

Example: COUNTIF(TotalFloat,">5") counts the number of activities who have a Total Float value greater than 5.